<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<%@ page pageEncoding="UTF-8" %>
<%@ include file="../common/common.jsp"%>
<%@ page import="jp.co.technotree.apl.api.common.Message,jp.co.technotree.common.ApplicationManager" %>
<jsp:useBean id="formBean" class="jp.co.technotree.apl.cmd.graph.Grp1000Bean" scope="request" />
<%
	String userId = formBean.getUserId();
	String userNm = formBean.getUserNm();

%>
<html>
	<head>
		<title>予備品管理システム - 材料費確認画面</title>
		<link rel="SHORTCUT ICON" href="../common/img/default/sys_icon.ico">

		<link rel='stylesheet' type='text/css' href='../../common/css/common/base.css' >
		<link rel='stylesheet' type='text/css' href='../../common/css/common/common.css'>
		<link rel='stylesheet' type='text/css' href='../../common/css/graph/grp1000.css'>

		<script language="javascript" src="../../common/js/base.js"></script>
		<script language="javascript" src="../../common/js/menu/topmenu.js"></script>

		<!--ポップアップ用-->
		<link rel='stylesheet' type='text/css' href='../../common/css/popUpPc.css' >
		<script type='text/javascript' src='../../common/js/popUpPc.js'></script>

		<!-- システムログ -->
		<script src="../../common/js/systemlog.js"></script>

		<style type='text/css'>
			.LinkItem {
				cursor: pointer;
			}
			.txtmode1 {
 				 ime-mode: active;   /* 全角モード */
			}
			.txtmode2 {
  				ime-mode: inactive; /* 半角モード */
			}
			.txtmode3 {
				ime-mode: disabled; /* 半角のみモード */
			}
		</style>

		<script language="javascript">
			function onInit(){
				//処理完了後、Msgを出してトップメニュー画面へ遷移
				var stateFlg = "<%=formBean.getStateFlg()%>";

				//var afterFunc="screen_back();"
				//if(stateFlg == "1"){
					//原価グラフを正常にExcelに出力しました
				//	alert_Custom2("<%=Message.getMessage("INF00060").replace("$1", "原価グラフ")%>",afterFunc);
				//}
				
				<%
				//--------------------------------
				//ダウンロード画面-START
				String popupFilePath = formBean.getExcelPath();
				if (popupFilePath != null && !"".equals(popupFilePath)) {
				%>
				var fn="<%=popupFilePath%>";
				var ft="10";
				var downTitleFlg="1";
				var excelTitleFlg="1";

				//1:受注, 2:出荷指示, 3:DNC納品書, 4:DNC納品書バーコード付き, 5:未納, 6:受領, 7:受領比較, 8:内示, 9:内示受注比較 ...他
					var features="location=no, menubar=no, status=no, scrollbars=no, resizable=yes, toolbar=no, width=510, height=400";
					window.open("../download/download?fn=" + fn + "&ft=" + ft + "&downTitleFlg=" + downTitleFlg + "&excelTitleFlg=" + excelTitleFlg, "_blank", features);
					
				<%
				}
				//ダウンロード画面-END
				//--------------------------------
				%>
				
				
			}
		
			function screen_back() {
				location.href="../topmenu/top1000.fw";
			}
			
			function outputExcel(){
				var afterFunc="yesOutputExcel();"
				if (!confirm_Custom3("<%=Message.getMessage("INF01160").replace("$1","原価グラフ")%>",afterFunc)){
					return ;
				}
			}

			
			
			// 3桁カンマ区切り
			function addFigure(idx) {
				var frm=document.main;
				
				obj_no =("0" + idx).slice(-2);
				str = frm["strMonBudget"+obj_no].value;
				
				var num = new String(str).replace(/,/g, "");

				while(num != (num = num.replace(/^(-?\d+)(\d{3})/, "$1,$2")));

				frm["strMonBudget"+obj_no].value = num;

			}
			
			// 3桁カンマ区切り
			function addFigure1(val) {
				
				var num = new String(val).replace(/,/g, "");

				while(num != (num = num.replace(/^(-?\d+)(\d{3})/, "$1,$2")));
				
				return num;
			}
			
			// カンマ除去
			function delComma(w) {
			    var z = w.replace(/,/g,"");
			    return (z);
			}
			
			// カンマ除去
			function delComma2(idx) {
				var frm=document.main;
				obj_no =("0" + idx).slice(-2);
				str = frm["strMonBudget"+obj_no].value;
				
				var num = new String(str).replace(/,/g, "");
				
				frm["strMonBudget"+obj_no].value = num;
				
			    //return (z);
			}
			
			//--------------------------------------------
			// 予算累計自動計算
			//--------------------------------------------

			function chgTotalBudget(idx){
				var frm = document.main;

				var bud01 = delComma(frm["strMonBudget01"].value);
				var bud02 = delComma(frm["strMonBudget02"].value);
				var bud03 = delComma(frm["strMonBudget03"].value);
				var bud04 = delComma(frm["strMonBudget04"].value);
				var bud05 = delComma(frm["strMonBudget05"].value);
				var bud06 = delComma(frm["strMonBudget06"].value);
				var bud07 = delComma(frm["strMonBudget07"].value);
				var bud08 = delComma(frm["strMonBudget08"].value);
				var bud09 = delComma(frm["strMonBudget09"].value);
				var bud10 = delComma(frm["strMonBudget10"].value);
				var bud11 = delComma(frm["strMonBudget11"].value);
				var bud12 = delComma(frm["strMonBudget12"].value);

				if (!bud01 && isNaN(bud01)) {bud01 = "0";}
				if (!bud02 && isNaN(bud02)) {bud02 = "0";}
				if (!bud03 && isNaN(bud03)) {bud03 = "0";}
				if (!bud04 && isNaN(bud04)) {bud04 = "0";}
				if (!bud05 && isNaN(bud05)) {bud05 = "0";}
				if (!bud06 && isNaN(bud06)) {bud06 = "0";}
				if (!bud07 && isNaN(bud07)) {bud07 = "0";}
				if (!bud08 && isNaN(bud08)) {bud08 = "0";}
				if (!bud09 && isNaN(bud09)) {bud09 = "0";}
				if (!bud10 && isNaN(bud10)) {bud10 = "0";}
				if (!bud11 && isNaN(bud11)) {bud11 = "0";}
				if (!bud12 && isNaN(bud12)) {bud12 = "0";}

				bud01 = Number(bud01);
				bud02 = Number(bud02);
				bud03 = Number(bud03);
				bud04 = Number(bud04);
				bud05 = Number(bud05);
				bud06 = Number(bud06);
				bud07 = Number(bud07);
				bud08 = Number(bud08);
				bud09 = Number(bud09);
				bud10 = Number(bud10);
				bud11 = Number(bud11);
				bud12 = Number(bud12);
				
				frm["strMonBudTotal01"].value = addFigure1(bud01);
				frm["strMonBudTotal02"].value = addFigure1(bud01 + bud02);
				frm["strMonBudTotal03"].value = addFigure1(bud01 + bud02 + bud03);
				frm["strMonBudTotal04"].value = addFigure1(bud01 + bud02 + bud03 + bud04);
				frm["strMonBudTotal05"].value = addFigure1(bud01 + bud02 + bud03 + bud04 + bud05);
				frm["strMonBudTotal06"].value = addFigure1(bud01 + bud02 + bud03 + bud04 + bud05 + bud06);
				frm["strMonBudTotal07"].value = addFigure1(bud01 + bud02 + bud03 + bud04 + bud05 + bud06 + bud07);
				frm["strMonBudTotal08"].value = addFigure1(bud01 + bud02 + bud03 + bud04 + bud05 + bud06 + bud07 + bud08);
				frm["strMonBudTotal09"].value = addFigure1(bud01 + bud02 + bud03 + bud04 + bud05 + bud06 + bud07 + bud08 + bud09);
				frm["strMonBudTotal10"].value = addFigure1(bud01 + bud02 + bud03 + bud04 + bud05 + bud06 + bud07 + bud08 + bud09 + bud10);
				frm["strMonBudTotal11"].value = addFigure1(bud01 + bud02 + bud03 + bud04 + bud05 + bud06 + bud07 + bud08 + bud09 + bud10 + bud11);
				frm["strMonBudTotal12"].value = addFigure1(bud01 + bud02 + bud03 + bud04 + bud05 + bud06 + bud07 + bud08 + bud09 + bud10 + bud11 + bud12);
				
				expensePercent();
				addFigure(idx);
			}

			function expensePercent(){
				var frm = document.main;

				// 3月の予算累計
				var budgetTotal = delComma(frm["strMonBudTotal12"].value);

				if(budgetTotal != 0){
					// 各月の実績累計
					var odrPerTotal01 = delComma(frm["strOdrPerTotal01"].value);
					var odrPerTotal02 = delComma(frm["strOdrPerTotal02"].value);
					var odrPerTotal03 = delComma(frm["strOdrPerTotal03"].value);
					var odrPerTotal04 = delComma(frm["strOdrPerTotal04"].value);
					var odrPerTotal05 = delComma(frm["strOdrPerTotal05"].value);
					var odrPerTotal06 = delComma(frm["strOdrPerTotal06"].value);
					var odrPerTotal07 = delComma(frm["strOdrPerTotal07"].value);
					var odrPerTotal08 = delComma(frm["strOdrPerTotal08"].value);
					var odrPerTotal09 = delComma(frm["strOdrPerTotal09"].value);
					var odrPerTotal10 = delComma(frm["strOdrPerTotal10"].value);
					var odrPerTotal11 = delComma(frm["strOdrPerTotal11"].value);
					var odrPerTotal12 = delComma(frm["strOdrPerTotal12"].value);

					// 再計算
					frm["strExpenseRate01"].value = addFigure1(Math.round((odrPerTotal01 / budgetTotal)*100))+"%";
					frm["strExpenseRate02"].value = addFigure1(Math.round((odrPerTotal02 / budgetTotal)*100))+"%";
					frm["strExpenseRate03"].value = addFigure1(Math.round((odrPerTotal03 / budgetTotal)*100))+"%";
					frm["strExpenseRate04"].value = addFigure1(Math.round((odrPerTotal04 / budgetTotal)*100))+"%";
					frm["strExpenseRate05"].value = addFigure1(Math.round((odrPerTotal05 / budgetTotal)*100))+"%";
					frm["strExpenseRate06"].value = addFigure1(Math.round((odrPerTotal06 / budgetTotal)*100))+"%";
					frm["strExpenseRate07"].value = addFigure1(Math.round((odrPerTotal07 / budgetTotal)*100))+"%";
					frm["strExpenseRate08"].value = addFigure1(Math.round((odrPerTotal08 / budgetTotal)*100))+"%";
					frm["strExpenseRate09"].value = addFigure1(Math.round((odrPerTotal09 / budgetTotal)*100))+"%";
					frm["strExpenseRate10"].value = addFigure1(Math.round((odrPerTotal10 / budgetTotal)*100))+"%";
					frm["strExpenseRate11"].value = addFigure1(Math.round((odrPerTotal11 / budgetTotal)*100))+"%";
					frm["strExpenseRate12"].value = addFigure1(Math.round((odrPerTotal12 / budgetTotal)*100))+"%";
				}else{
					// 0を設定
					frm["strExpenseRate01"].value = "0%";
					frm["strExpenseRate02"].value = "0%";
					frm["strExpenseRate03"].value = "0%";
					frm["strExpenseRate04"].value = "0%";
					frm["strExpenseRate05"].value = "0%";
					frm["strExpenseRate06"].value = "0%";
					frm["strExpenseRate07"].value = "0%";
					frm["strExpenseRate08"].value = "0%";
					frm["strExpenseRate09"].value = "0%";
					frm["strExpenseRate10"].value = "0%";
					frm["strExpenseRate11"].value = "0%";
					frm["strExpenseRate12"].value = "0%";
				}

			}

			// 年度検索
			function formSubmit() {
				var frm = document.main;
				//frm.cmd.value = "cmd01";
				frm.submitFlag.value = "1";
				frm.submit();
			}
			// Excel発行
			function yesOutputExcel(){
				var frm = document.main;
				frm.exeExcel.value = "1";
				frm.submitFlag.value = "1";
				frm.submit();
			}
			
			//数字しか入力できないように
			function numberKeyPress(){
				//備考：少数点とかマイナスを入力させるには48ではなく45かな？
				if ((event.keyCode < 48) || (event.keyCode > 57)){event.returnValue = false;};
			}
			
			//-------------------------------------------------------------------------
			//<!-- ポップアップ START -->

			//ポップアップ解除
			function back(){
				document.getElementById("opAlertBtn").style.display = "none";
				document.getElementById("opAlert").style.display = "none";
				document.getElementById("opAlertButton").style.display = "none";
				document.getElementById("opAlertTop").style.display = "none";
				document.getElementById("allbackgr").style.display = "none";
			}

			//<!-- ポップアップ END -->
			//-------------------------------------------------------------------------
			</script>

	</head>

	<body onLoad="onInit()" style="margin: 0px 4px 0px 0px;">
		<form class="frmMain" name="main" action="./grp1000" method="post" enctype="multipart/form-data" onsubmit="return false;">
			<table class="tblMain" width="100%" cellspacing="0" cellpadding="0" border="0">
				<tr>
					<td valign="top">
						
						<!-- Header Menu START -->
						<div class="header-title">予備品管理システム(<%=formBean.kojou%>)</div>
						<!-- Header Menu END -->

						<!-- ***** [FORM] MAIN-FORM ***** -->
						<div id="lc-out" style="z-index: 0;">
							<div id="lc-in" style="z-index: 0">

								<div  class="txtcenter" style="margin: 20px ; width: 98%;">
									<div class="subtitle">材料費確認画面</div>
									<table  border="0" style="width: 98%;">
										<tr>
											<td>
												<table border="0" style="width:98%;  margin-left: 35px;"">
													<tr>
														<td style="width:200px;" >
														<select id="findYear" name="findYear" style="width:180px; text-align: center;" onchange="formSubmit();">
															<option value="2000" <%="2000".equals(formBean.getFindYear()) ? "selected" : "" %> >2000</option>
															<option value="2001" <%="2001".equals(formBean.getFindYear()) ? "selected" : "" %> >2001</option>
															<option value="2002" <%="2002".equals(formBean.getFindYear()) ? "selected" : "" %> >2002</option>
															<option value="2003" <%="2003".equals(formBean.getFindYear()) ? "selected" : "" %> >2003</option>
															<option value="2004" <%="2004".equals(formBean.getFindYear()) ? "selected" : "" %> >2004</option>
															<option value="2005" <%="2005".equals(formBean.getFindYear()) ? "selected" : "" %> >2005</option>
															<option value="2006" <%="2006".equals(formBean.getFindYear()) ? "selected" : "" %> >2006</option>
															<option value="2007" <%="2007".equals(formBean.getFindYear()) ? "selected" : "" %> >2007</option>
															<option value="2008" <%="2008".equals(formBean.getFindYear()) ? "selected" : "" %> >2008</option>
															<option value="2009" <%="2009".equals(formBean.getFindYear()) ? "selected" : "" %> >2009</option>
															<option value="2010" <%="2010".equals(formBean.getFindYear()) ? "selected" : "" %> >2010</option>
															<option value="2011" <%="2011".equals(formBean.getFindYear()) ? "selected" : "" %> >2011</option>
															<option value="2012" <%="2012".equals(formBean.getFindYear()) ? "selected" : "" %> >2012</option>
															<option value="2013" <%="2013".equals(formBean.getFindYear()) ? "selected" : "" %> >2013</option>
															<option value="2014" <%="2014".equals(formBean.getFindYear()) ? "selected" : "" %> >2014</option>
															<option value="2015" <%="2015".equals(formBean.getFindYear()) ? "selected" : "" %> >2015</option>
															<option value="2016" <%="2016".equals(formBean.getFindYear()) ? "selected" : "" %> >2016</option>
															<option value="2017" <%="2017".equals(formBean.getFindYear()) ? "selected" : "" %> >2017</option>
															<option value="2018" <%="2018".equals(formBean.getFindYear()) ? "selected" : "" %> >2018</option>
															<option value="2019" <%="2019".equals(formBean.getFindYear()) ? "selected" : "" %> >2019</option>
															<option value="2020" <%="2020".equals(formBean.getFindYear()) ? "selected" : "" %> >2020</option>
															<option value="2021" <%="2021".equals(formBean.getFindYear()) ? "selected" : "" %> >2021</option>
															<option value="2022" <%="2022".equals(formBean.getFindYear()) ? "selected" : "" %> >2022</option>
															<option value="2023" <%="2023".equals(formBean.getFindYear()) ? "selected" : "" %> >2023</option>
															<option value="2024" <%="2024".equals(formBean.getFindYear()) ? "selected" : "" %> >2024</option>
															<option value="2025" <%="2025".equals(formBean.getFindYear()) ? "selected" : "" %> >2025</option>
															<option value="2026" <%="2026".equals(formBean.getFindYear()) ? "selected" : "" %> >2026</option>
															<option value="2027" <%="2027".equals(formBean.getFindYear()) ? "selected" : "" %> >2027</option>
															<option value="2028" <%="2028".equals(formBean.getFindYear()) ? "selected" : "" %> >2028</option>
															<option value="2029" <%="2029".equals(formBean.getFindYear()) ? "selected" : "" %> >2029</option>
															<option value="2030" <%="2030".equals(formBean.getFindYear()) ? "selected" : "" %> >2030</option>
															<option value="2031" <%="2031".equals(formBean.getFindYear()) ? "selected" : "" %> >2031</option>
															<option value="2032" <%="2032".equals(formBean.getFindYear()) ? "selected" : "" %> >2032</option>
															<option value="2033" <%="2033".equals(formBean.getFindYear()) ? "selected" : "" %> >2033</option>
															<option value="2034" <%="2034".equals(formBean.getFindYear()) ? "selected" : "" %> >2034</option>
															<option value="2035" <%="2035".equals(formBean.getFindYear()) ? "selected" : "" %> >2035</option>
															<option value="2036" <%="2036".equals(formBean.getFindYear()) ? "selected" : "" %> >2036</option>
															<option value="2037" <%="2037".equals(formBean.getFindYear()) ? "selected" : "" %> >2037</option>
															<option value="2038" <%="2038".equals(formBean.getFindYear()) ? "selected" : "" %> >2038</option>
															<option value="2039" <%="2039".equals(formBean.getFindYear()) ? "selected" : "" %> >2039</option>
															<option value="2040" <%="2040".equals(formBean.getFindYear()) ? "selected" : "" %> >2040</option>
															<option value="2041" <%="2041".equals(formBean.getFindYear()) ? "selected" : "" %> >2041</option>
															<option value="2042" <%="2042".equals(formBean.getFindYear()) ? "selected" : "" %> >2042</option>
															<option value="2043" <%="2043".equals(formBean.getFindYear()) ? "selected" : "" %> >2043</option>
															<option value="2044" <%="2044".equals(formBean.getFindYear()) ? "selected" : "" %> >2044</option>
															<option value="2045" <%="2045".equals(formBean.getFindYear()) ? "selected" : "" %> >2045</option>
															<option value="2046" <%="2046".equals(formBean.getFindYear()) ? "selected" : "" %> >2046</option>
															<option value="2047" <%="2047".equals(formBean.getFindYear()) ? "selected" : "" %> >2047</option>
															<option value="2048" <%="2048".equals(formBean.getFindYear()) ? "selected" : "" %> >2048</option>
															<option value="2049" <%="2049".equals(formBean.getFindYear()) ? "selected" : "" %> >2049</option>
															<option value="2050" <%="2050".equals(formBean.getFindYear()) ? "selected" : "" %> >2050</option>
														</select>
														</td>
														<td>
															年度
														</td>
													</tr>
													<tr height="10px"><td></td>	</tr>
												</table>
											</td>
										</tr>
										<tr>
											<td>
												<div style="border: solid 1px;">
													<table  border="1" width="1300px" height="30px" class="data-grid" >
														<thead>
															<tr>
																<th colspan="13"" style="font-size:18px;"><%=formBean.kojou%></th>
															</tr>
															<tr>
																<th style="width:100px;font-size:16px;">&nbsp;</th>
																<th style="width:100px;font-size:16px;">4月</th>
																<th style="width:100px;font-size:16px;">5月</th>
																<th style="width:100px;font-size:16px;">6月</th>
																<th style="width:100px;font-size:16px;">7月</th>
																<th style="width:100px;font-size:16px;">8月</th>
																<th style="width:100px;font-size:16px;">9月</th>
																<th style="width:100px;font-size:16px;">10月</th>
																<th style="width:100px;font-size:16px;">11月</th>
																<th style="width:100px;font-size:16px;">12月</th>
																<th style="width:100px;font-size:16px;">1月</th>
																<th style="width:100px;font-size:16px;">2月</th>
																<th style="width:100px;font-size:16px;">3月</th>
															</tr>
														</thead>
														<tr style="background-color:#ffffff;">
															<td class="txtCenter" style="font-size:13px;">予算単月</td>
															<td>
																<input type="text" style="width:100px;" class="txtmode3 txtRight" name="strMonBudget01" id="strMonBudget01"  value="<%=formBean.getStrMonBudget01() %>"  onchange="chgTotalBudget('1');" onfocus="delComma2('1');" onblur="addFigure('1');" onKeyPress="numberKeyPress();" maxlength="12">
															</td>
															<td>
																<input type="text" style="width:100px;" class="txtmode3 txtRight" name="strMonBudget02" id="strMonBudget02"  value="<%=formBean.getStrMonBudget02() %>"  onchange="chgTotalBudget('2');" onfocus="delComma2('2');" onblur="addFigure('2');" onKeyPress="numberKeyPress();" maxlength="12">
															</td>
															<td>
																<input type="text" style="width:100px;" class="txtmode3 txtRight" name="strMonBudget03" id="strMonBudget03"  value="<%=formBean.getStrMonBudget03() %>"  onchange="chgTotalBudget('3');" onfocus="delComma2('3');" onblur="addFigure('3');" onKeyPress="numberKeyPress();" maxlength="12">
															</td>
															<td>
																<input type="text" style="width:100px;" class="txtmode3 txtRight" name="strMonBudget04" id="strMonBudget04"  value="<%=formBean.getStrMonBudget04() %>"  onchange="chgTotalBudget('4');" onfocus="delComma2('4');" onblur="addFigure('4');" onKeyPress="numberKeyPress();" maxlength="12">
															</td>
															<td>
																<input type="text" style="width:100px;" class="txtmode3 txtRight" name="strMonBudget05" id="strMonBudget05"  value="<%=formBean.getStrMonBudget05() %>"  onchange="chgTotalBudget('5');" onfocus="delComma2('5');" onblur="addFigure('5');" onKeyPress="numberKeyPress();" maxlength="12">
															</td>
															<td>
																<input type="text" style="width:100px;" class="txtmode3 txtRight" name="strMonBudget06" id="strMonBudget06"  value="<%=formBean.getStrMonBudget06() %>"  onchange="chgTotalBudget('6');" onfocus="delComma2('6');" onblur="addFigure('6');" onKeyPress="numberKeyPress();" maxlength="12">
															</td>
															<td>
																<input type="text" style="width:100px;" class="txtmode3 txtRight" name="strMonBudget07" id="strMonBudget07"  value="<%=formBean.getStrMonBudget07() %>"  onchange="chgTotalBudget('7');" onfocus="delComma2('7');" onblur="addFigure('7');" onKeyPress="numberKeyPress();" maxlength="12">
															</td>
															<td>
																<input type="text" style="width:100px;" class="txtmode3 txtRight" name="strMonBudget08" id="strMonBudget08"  value="<%=formBean.getStrMonBudget08() %>"  onchange="chgTotalBudget('8');" onfocus="delComma2('8');" onblur="addFigure('8');" onKeyPress="numberKeyPress();" maxlength="12">
															</td>
															<td>
																<input type="text" style="width:100px;" class="txtmode3 txtRight" name="strMonBudget09" id="strMonBudget09"  value="<%=formBean.getStrMonBudget09() %>"  onchange="chgTotalBudget('9');" onfocus="delComma2('9');" onblur="addFigure('9');" onKeyPress="numberKeyPress();" maxlength="12">
															</td>
															<td>
																<input type="text" style="width:100px;" class="txtmode3 txtRight" name="strMonBudget10" id="strMonBudget10"  value="<%=formBean.getStrMonBudget10() %>"  onchange="chgTotalBudget('10');" onfocus="delComma2('10');" onblur="addFigure('10');" onKeyPress="numberKeyPress();" maxlength="12">
															</td>
															<td>
																<input type="text" style="width:100px;" class="txtmode3 txtRight" name="strMonBudget11" id="strMonBudget11"  value="<%=formBean.getStrMonBudget11() %>"  onchange="chgTotalBudget('11');" onfocus="delComma2('11');" onblur="addFigure('11');" onKeyPress="numberKeyPress();" maxlength="12">
															</td>
															<td>
																<input type="text" style="width:100px;" class="txtmode3 txtRight" name="strMonBudget12" id="strMonBudget12"  value="<%=formBean.getStrMonBudget12() %>"  onchange="chgTotalBudget('12');" onfocus="delComma2('12');" onblur="addFigure('12');" onKeyPress="numberKeyPress();" maxlength="12">
															</td>
														</tr>
														<tr class="listBackMode1">
															<td class="txtCenter" style="font-size:13px;">実績単月</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode1"  name="strOdrPer01" id="strOdrPer01"  value="<%=formBean.getStrOdrPer01() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode1"  name="strOdrPer02" id="strOdrPer02"  value="<%=formBean.getStrOdrPer02() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode1"  name="strOdrPer03" id="strOdrPer03"  value="<%=formBean.getStrOdrPer03() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode1"  name="strOdrPer04" id="strOdrPer04"  value="<%=formBean.getStrOdrPer04() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode1"  name="strOdrPer05" id="strOdrPer05"  value="<%=formBean.getStrOdrPer05() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode1"  name="strOdrPer06" id="strOdrPer06"  value="<%=formBean.getStrOdrPer06() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode1"  name="strOdrPer07" id="strOdrPer07"  value="<%=formBean.getStrOdrPer07() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode1"  name="strOdrPer08" id="strOdrPer08"  value="<%=formBean.getStrOdrPer08() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode1"  name="strOdrPer09" id="strOdrPer09"  value="<%=formBean.getStrOdrPer09() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode1"  name="strOdrPer10" id="strOdrPer10"  value="<%=formBean.getStrOdrPer10() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode1"  name="strOdrPer11" id="strOdrPer11"  value="<%=formBean.getStrOdrPer11() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode1"  name="strOdrPer12" id="strOdrPer12"  value="<%=formBean.getStrOdrPer12() %>"  readonly>
															</td>
														</tr>
														<tr class="listBackMode2">
															<td class="txtCenter"  style="font-size:13px;">未入荷入荷予定</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode2"  name="strArrivalPlan01" id="strArrivalPlan01"  value="<%=formBean.getStrArrivalPlan01() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode2"  name="strArrivalPlan02" id="strArrivalPlan02"  value="<%=formBean.getStrArrivalPlan02() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode2"  name="strArrivalPlan03" id="strArrivalPlan03"  value="<%=formBean.getStrArrivalPlan03() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode2"  name="strArrivalPlan04" id="strArrivalPlan04"  value="<%=formBean.getStrArrivalPlan04() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode2"  name="strArrivalPlan05" id="strArrivalPlan05"  value="<%=formBean.getStrArrivalPlan05() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode2"  name="strArrivalPlan06" id="strArrivalPlan06"  value="<%=formBean.getStrArrivalPlan06() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode2"  name="strArrivalPlan07" id="strArrivalPlan07"  value="<%=formBean.getStrArrivalPlan07() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode2"  name="strArrivalPlan08" id="strArrivalPlan08"  value="<%=formBean.getStrArrivalPlan08() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode2"  name="strArrivalPlan09" id="strArrivalPlan09"  value="<%=formBean.getStrArrivalPlan09() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode2"  name="strArrivalPlan10" id="strArrivalPlan10"  value="<%=formBean.getStrArrivalPlan10() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode2"  name="strArrivalPlan11" id="strArrivalPlan11"  value="<%=formBean.getStrArrivalPlan11() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode2"  name="strArrivalPlan12" id="strArrivalPlan12"  value="<%=formBean.getStrArrivalPlan12() %>"  readonly>
																<input type="hidden" style="width:100px;"  class="txtRight listBackMode2"  name="strArrivalPlan13" id="strArrivalPlan13"  value="<%=formBean.getStrArrivalPlan13() %>"  readonly>
																<input type="hidden" style="width:100px;"  class="txtRight listBackMode2"  name="strArrivalPlan14" id="strArrivalPlan14"  value="<%=formBean.getStrArrivalPlan14() %>"  readonly>
															</td>
														</tr>
														<tr class="listBackMode3">
															<td class="txtCenter" style="font-size:13px;">予算累計</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode3"  name="strMonBudTotal01" id="strMonBudTotal01"  value="<%=formBean.getStrMonBudTotal01() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode3"  name="strMonBudTotal02" id="strMonBudTotal02"  value="<%=formBean.getStrMonBudTotal02() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode3"  name="strMonBudTotal03" id="strMonBudTotal03"  value="<%=formBean.getStrMonBudTotal03() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode3"  name="strMonBudTotal04" id="strMonBudTotal04"  value="<%=formBean.getStrMonBudTotal04() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode3"  name="strMonBudTotal05" id="strMonBudTotal05"  value="<%=formBean.getStrMonBudTotal05() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode3"  name="strMonBudTotal06" id="strMonBudTotal06"  value="<%=formBean.getStrMonBudTotal06() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode3"  name="strMonBudTotal07" id="strMonBudTotal07"  value="<%=formBean.getStrMonBudTotal07() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode3"  name="strMonBudTotal08" id="strMonBudTotal08"  value="<%=formBean.getStrMonBudTotal08() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode3"  name="strMonBudTotal09" id="strMonBudTotal09"  value="<%=formBean.getStrMonBudTotal09() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode3"  name="strMonBudTotal10" id="strMonBudTotal10"  value="<%=formBean.getStrMonBudTotal10() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode3"  name="strMonBudTotal11" id="strMonBudTotal11"  value="<%=formBean.getStrMonBudTotal11() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode3"  name="strMonBudTotal12" id="strMonBudTotal12"  value="<%=formBean.getStrMonBudTotal12() %>"  readonly>
															</td>
														</tr>
														<tr class="listBackMode4">
															<td class="txtCenter" style="font-size:13px;">実績累計</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode4"  name="strOdrPerTotal01" id="strOdrPerTotal01"  value="<%=formBean.getStrOdrPerTotal01() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode4"  name="strOdrPerTotal02" id="strOdrPerTotal02"  value="<%=formBean.getStrOdrPerTotal02() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode4"  name="strOdrPerTotal03" id="strOdrPerTotal03"  value="<%=formBean.getStrOdrPerTotal03() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode4"  name="strOdrPerTotal04" id="strOdrPerTotal04"  value="<%=formBean.getStrOdrPerTotal04() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode4"  name="strOdrPerTotal05" id="strOdrPerTotal05"  value="<%=formBean.getStrOdrPerTotal05() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode4"  name="strOdrPerTotal06" id="strOdrPerTotal06"  value="<%=formBean.getStrOdrPerTotal06() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode4"  name="strOdrPerTotal07" id="strOdrPerTotal07"  value="<%=formBean.getStrOdrPerTotal07() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode4"  name="strOdrPerTotal08" id="strOdrPerTotal08"  value="<%=formBean.getStrOdrPerTotal08() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode4"  name="strOdrPerTotal09" id="strOdrPerTotal09"  value="<%=formBean.getStrOdrPerTotal09() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode4"  name="strOdrPerTotal10" id="strOdrPerTotal10"  value="<%=formBean.getStrOdrPerTotal10() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode4"  name="strOdrPerTotal11" id="strOdrPerTotal11"  value="<%=formBean.getStrOdrPerTotal11() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode4"  name="strOdrPerTotal12" id="strOdrPerTotal12"  value="<%=formBean.getStrOdrPerTotal12() %>"  readonly>
															</td>
														</tr>
														<tr class="listBackMode5">
															<td class="txtCenter" style="font-size:13px;">累計消費率</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode5"  name="strExpenseRate01" id="strExpenseRate01"  value="<%=formBean.getStrExpenseRate01() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode5" name="strExpenseRate02" id="strExpenseRate02"  value="<%=formBean.getStrExpenseRate02() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode5"  name="strExpenseRate03" id="strExpenseRate03"  value="<%=formBean.getStrExpenseRate03() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode5"  name="strExpenseRate04" id="strExpenseRate04"  value="<%=formBean.getStrExpenseRate04() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode5"  name="strExpenseRate05" id="strExpenseRate05"  value="<%=formBean.getStrExpenseRate05() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode5"  name="strExpenseRate06" id="strExpenseRate06"  value="<%=formBean.getStrExpenseRate06() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode5"  name="strExpenseRate07" id="strExpenseRate07"  value="<%=formBean.getStrExpenseRate07() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode5"  name="strExpenseRate08" id="strExpenseRate08"  value="<%=formBean.getStrExpenseRate08() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode5"  name="strExpenseRate09" id="strExpenseRate09"  value="<%=formBean.getStrExpenseRate09() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode5"  name="strExpenseRate10" id="strExpenseRate10"  value="<%=formBean.getStrExpenseRate10() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode5"  name="strExpenseRate11" id="strExpenseRate11"  value="<%=formBean.getStrExpenseRate11() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode5"  name="strExpenseRate12" id="strExpenseRate12"  value="<%=formBean.getStrExpenseRate12() %>"  readonly>
															</td>
														</tr>
														<tr class="listBackMode6">
															<td class="txtCenter" style="font-size:13px;">発注単月</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrVal01" id ="strOdrVal01"  value="<%=formBean.getStrOdrVal01() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrVal02" id ="strOdrVal02"  value="<%=formBean.getStrOdrVal02() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrVal03" id ="strOdrVal03"  value="<%=formBean.getStrOdrVal03() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrVal04" id ="strOdrVal04"  value="<%=formBean.getStrOdrVal04() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrVal05" id ="strOdrVal05"  value="<%=formBean.getStrOdrVal05() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrVal06" id ="strOdrVal06"  value="<%=formBean.getStrOdrVal06() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrVal07" id ="strOdrVal07"  value="<%=formBean.getStrOdrVal07() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrVal08" id ="strOdrVal08"  value="<%=formBean.getStrOdrVal08() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrVal09" id ="strOdrVal09"  value="<%=formBean.getStrOdrVal09() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrVal10" id ="strOdrVal10"  value="<%=formBean.getStrOdrVal10() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrVal11" id ="strOdrVal11"  value="<%=formBean.getStrOdrVal11() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrVal12" id ="strOdrVal12"  value="<%=formBean.getStrOdrVal12() %>"  readonly>
															</td>
														</tr>
														<tr class="listBackMode6">
															<td class="txtCenter" style="font-size:13px;">発注累計</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrValTotal01" id ="strOdrValTotal01"  value="<%=formBean.getStrOdrValTotal01() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrValTotal02" id ="strOdrValTotal02"  value="<%=formBean.getStrOdrValTotal02() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrValTotal03" id ="strOdrValTotal03"  value="<%=formBean.getStrOdrValTotal03() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrValTotal04" id ="strOdrValTotal04"  value="<%=formBean.getStrOdrValTotal04() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrValTotal05" id ="strOdrValTotal05"  value="<%=formBean.getStrOdrValTotal05() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrValTotal06" id ="strOdrValTotal06"  value="<%=formBean.getStrOdrValTotal06() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrValTotal07" id ="strOdrValTotal07"  value="<%=formBean.getStrOdrValTotal07() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrValTotal08" id ="strOdrValTotal08"  value="<%=formBean.getStrOdrValTotal08() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrValTotal09" id ="strOdrValTotal09"  value="<%=formBean.getStrOdrValTotal09() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrValTotal10" id ="strOdrValTotal10"  value="<%=formBean.getStrOdrValTotal10() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrValTotal11" id ="strOdrValTotal11"  value="<%=formBean.getStrOdrValTotal11() %>"  readonly>
															</td>
															<td>
																<input type="text" style="width:100px;"  class="txtRight listBackMode6"  name = "strOdrValTotal12" id ="strOdrValTotal12"  value="<%=formBean.getStrOdrValTotal12() %>"  readonly>
															</td>
														</tr>
													</table>
												</div>
											</td>
										</tr>
									</table>
								</div>
								<div class="txtcenter" style="margin: 10px; width: 98%;">
								<table  border="0" style="width: 98%;">
									<tr>
										<td class="txtright">
											<input type="image" src="../../common/img/pc/btn_excel_out_off.png" onclick="outputExcel();" alt="Excel出力">
											&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
											<input type="image" src="../../common/img/pc/btn_back_off.png" onclick="screen_back();">
										</td>
									</tr>
									<tr height="25px"><td></td></tr>
								</table>
							</div>
							</div><!-- lc-in End -->
						</div><!-- lc-out  -->
					</td>
				</tr>
			</table>

			<input type="hidden" name="cmd" value="cmd01">
			<input type="hidden" name="submitFlag" id="submitFlag" value="">
			<input type="hidden" name="exeExcel" id="exeExcel" value="">
			<input type="hidden" name="uplodFile" id="uplodFile" value="">
			<input type="hidden" name="deleteSheet" id="deleteSheet" value="">
			<input type="hidden" name="deleteSheetName" id="deleteSheetName" value="">
			<input type="hidden" name="upTest" id="upTest" value="">
			
			<!--警告 ポップアップ---------------------------------------------------------------------------- -->
			<div id="allbackgr" class="allbackgr" style="display:none;"></div>
			<div class="opAlertBtn" id = "opAlertBtn" style="display:none;" ></div>
			<div class="opAlertButton" id = "opAlertButton" style="display:none;" ></div>
			<div class="opAlertTop" id = "opAlertTop" style="display:none; font-size:22px;">　予備品管理システム　</div>
			<div class="opAlert" id = "opAlert" style="display:none;"></div>
			<!-- -------------------------------------------------------------------------------------------- -->
			
		</form>
	</body>
</html>
